Pre-query Slicers allow you to set the slicer selections for specified slicers and parameters upon launching the presentation in runtime, before the query is loaded. You can also create pre-query bookmarks to save multiple slicer selection combinations and apply them simultaneously.
Pre-query Slicers are available in Discover, Present, and Tabulate.
Note: This feature is not supported for SAP HANA or BW models containing predefined parameters.
Add Pre-Query Slicers
Existing Pre-Query Slicers
You can add existing pre-query slicers from the Content panel to your presentation. In this case, no further configuration is required, as the slicer has already been set as pre-query.
Create Pre-Query Slicers
To create Pre-query Slicers, open the Slicer Settings panel for the relevant slicer or parameter. From the Other Settings (green highlight below) enable the pre-query slicer option (green arrow below):
Select Pre-Query Slicers
When you launch a presentation at runtime that contains pre-query slicers you will be presented with the pre-query Slicer dialog (image below). The dialog presents all pre-query slicers in the report; each slicer can be searched and enabled or disabled as needed.
- To load the query, you must fist select the required slicer values (purple highlight below).
- Save your slicer selections as bookmarks (yellow highlight below) so that you can quickly select 1 or more slicer values at once.
- To revert to the default slicer selection, click Restore Defaults (green highlight below).
Pre-Query Slicers from Multiple Sources
If your presentation contains pre-query slicers from multiple sources, they will be arranged by data model, as in the image below.
Navigate the list of data models (yellow highlight below) to expose the slicers; be sure to make slicer selections for all slicers, or disable any slicers you don't want to affect the query.
Pre-Query Bookmarks
Bookmarks allow you to save multiple pre-query slicer selections. You can then select the required bookmark to load multiple slicer selections into the query, rather than manually changing each of the slicers.
You can save multiple pre-query bookmarks pointing to different combinations of slicer selections. Bookmarks are not shareable and will only be seen by the current user.
Pre-query bookmarks are similar in concept to Presentation Bookmarks. However, they are only available for pre-query slicers, from the pre-query slicer dialog. They will not appear in your list of presentation bookmarks.
To create a pre-query slicer bookmark:
- Make the required slicer selections from the Pre-query Slicers dialog.
- Click the plus sign + next to the Bookmarks field; the slicer selections will be added to a drop-down list.
- Next time you open the Pre-query Slicers dialog, your bookmark will appear in the Bookmarks drop down list. Select the required bookmark and click "Apply" to load the query.
To edit or delete a bookmark, select it from the list and click the edit icon.
- Click here to learn how to manage bookmarks.
Note: Pre-query slicer bookmarks are saved only to the current report for the current user.
Manage Pre-Query Slicers
When pre-query slicers are enabled in the presentation, the Pre-query Slicer button will appear in the Presentation menu (yellow highlight below). Click this button to open the Pre-query Slicer dialog (as shown above), where you can add, edit, and delete pre-query slicer bookmarks.
